Because of the recent international go to Oracle on MySQL, this inevitably involves time zone and timestamp issues. Do an experiment and summarize.OracleFirst look at the definition of Oracle Concepts for timestamp:The TIMESTAMP data type is an
Oracle 9i has three Data Types About Time: Timestamp [(precision)] timestamp [(precision)] with Time Zone timestamp [(precision)] with local time zone, timestamp [(precision)] with Time Zone stores time zone information.
1. Oracle time zone settings
There are two clocks in linux, but the time zone in linux is somewhat different from that in China. Let's take a look at how to modify and view the time zone and Time Zone in Linux.
1. Modify the time zone
1. view the current time zone
Date-R
2.
One, modify the time zone
1. View the current time zone
Date-r
2. Modify Settings Time zone
Select target time zone with Tzselect
Tzselect
According to the prompts to select the appropriate time zone, and finally get the time zone settings,
Timestamp with Loca time zone type syntax
tmestamp[(Fractional_seconds_precisions)] with the local zone
The biggest difference between the timestamp with the local time zone and the timesatamp with times zone is that the type converts to the
Windows dynamic disk volume: simple volume, cross-zone volume, with-zone volume, image volume, RAID5 volume configuration operations, cross-zone raid5
Windows Server 2003 provides a new disk management method to improve disk performance and fault
MySQL Time Zone modification method summary, mysql Time Zone Summary
This example summarizes how MySQL modifies the time zone. We will share this with you for your reference. The details are as follows:
Note:Here we will summarize three methods for
Sharing the SQL area, private SQL area, and game Benchmark 1. Sharing the SQL area is another way to name the handle of the cursor object in Librarycace and the data of the Child heap. Ii. Concept of private SQL zone is stored in PGA in dedicated
About the time zone designCrape Myrtle Live Li WanhongBecause the system uses different geography, time zone and time are different, therefore, the time zone processing needs to be designed to ensure that the system time is correct. Each site's time
Shared SQL zone, private SQL zone, and cursor
I. Share the SQL ZoneThe shared SQL zone is another way of calling the handle of the cursor object in the Library cace and the data of the Child heap.Ii. Concept of private SQL ZonePrivate SQL zone,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.